The Create Running Total Field dialog box appears when you select Running Total Fields in the Field Explorer and then click the New button. This is the same as the Edit Running Total Field dialog box that appears when you edit a running total field in the Field Explorer or directly from the report. This description applies to both dialog boxes.
Use these dialog boxes to create or edit running total fields. Running totals are totals that are displayed on a record by record basis. Running Totals total all records (in the report, in the group, and so on) up to and including the current record. For example, if your first three records have values of 2, 4, and 7, the running total for each of the three records would be as follows:
Lists all tables and fields in the report. Choose the field you want to summarize (the field on which a running total will be based) from this list.
Type the name of your running total, for example Last Year's Sales, into the Running Total Name box.
The Field to summarize list will display a field you select from the Available Tables and Fields list. The running total you are creating will be based on the field in the Field to summarize list.
Note: Use the Add button (>) to copy a field from the Available Tables and Fields list to the Field to summarize list.
Use the Type of summary list to select from a number of summary options. The summary type you choose will determine the running total calculation. For example, if you chose Customer.Last Year's Sales as the field to summarize, you can choose to have your running total field perform sum, average, or sample variance calculations on the selected field, to name only a few summary types.
Note: Summary
Use the For each record option to have your running total evaluate each record in a field.
Use the On change of field option to have your running total perform its evaluation only when a specified field has changed.
Note: Use the Add button (>) to copy a field from the Available Tables and Fields list to the On change of field list.
Use the On change of group option to have your running total perform its evaluation only when a specified group has changed.
Select the Use a formula option to have your running total use a formula when performing its calculations.
Use the Never option to lock your running total field. With the Never button selected, your running total will perform its calculations on that field throughout the entire report.
Use the On change of field list to have your running total evaluate or reset when a designated field changes.
Note: Use the Add button (>) to copy a field from the Available Tables and Fields list to the On change of field list.
Use the On change of group list to have your running total evaluate or reset when a designated group changes.
Select the Use a formula option to have your running total use a formula to determine when to reset.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |